{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "data_15_filepath = r'/home/baby/AnaFenye/叶片结冰预测/train/15/15_data.csv'\n",
    "data_15_fail = r'/home/baby/AnaFenye/叶片结冰预测/train/15/15_failureInfo.csv'\n",
    "data_15_norm = r'/home/baby/AnaFenye/叶片结冰预测/train/15/15_normalInfo.csv'\n",
    "\n",
    "data_15_df = pd.read_csv(data_15_filepath)\n",
    "data_15_fail_df = pd.read_csv(data_15_fail)\n",
    "data_15_norm_df = pd.read_csv(data_15_norm)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#初始化一个array作为数据的flag\n",
    "flag_15 = np.ones(data_15_df.shape[0])*3\n",
    "\n",
    "#定义一个函数，判断是否存在于正内常或者失败的时间段\n",
    "def addFlag1(x,tf_df=data_15_fail_df):\n",
    "    tem_res = np.logical_and(tf_df['startTime']<=x,tf_df['endTime']>=x)\n",
    "    return tem_res.any()\n",
    "\n",
    "def addFlag0(x,tf_df=data_15_norm_df):\n",
    "    tem_res = np.logical_and(tf_df['startTime']<=x,tf_df['endTime']>=x)\n",
    "    return tem_res.any()\n",
    "\n",
    "# flag_15[(data_15_df['time'][flag_15==3]).apply(addFlag1)]=1\n",
    "# flag_15[(data_15_df['time'][flag_15==3]).apply(addFlag0)]=0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         2015-11-01 20:20:16\n",
       "1         2015-11-01 20:20:23\n",
       "2         2015-11-01 20:20:30\n",
       "3         2015-11-01 20:20:37\n",
       "4         2015-11-01 20:20:47\n",
       "5         2015-11-01 20:20:54\n",
       "6         2015-11-01 20:21:01\n",
       "7         2015-11-01 20:21:08\n",
       "8         2015-11-01 20:21:15\n",
       "9         2015-11-01 20:21:22\n",
       "10        2015-11-01 20:21:29\n",
       "11        2015-11-01 20:21:36\n",
       "12        2015-11-01 20:21:43\n",
       "13        2015-11-01 20:21:50\n",
       "14        2015-11-01 20:21:57\n",
       "15        2015-11-01 20:22:04\n",
       "16        2015-11-01 20:22:11\n",
       "17        2015-11-01 20:22:18\n",
       "18        2015-11-01 20:22:25\n",
       "19        2015-11-01 20:22:32\n",
       "20        2015-11-01 20:22:39\n",
       "21        2015-11-01 20:22:49\n",
       "22        2015-11-01 20:22:56\n",
       "23        2015-11-01 20:23:03\n",
       "24        2015-11-01 20:23:10\n",
       "25        2015-11-01 20:23:17\n",
       "26        2015-11-01 20:23:24\n",
       "27        2015-11-01 20:23:31\n",
       "28        2015-11-01 20:23:38\n",
       "29        2015-11-01 20:23:45\n",
       "                 ...         \n",
       "393856    2016-01-01 21:34:36\n",
       "393857    2016-01-01 21:34:43\n",
       "393858    2016-01-01 21:34:50\n",
       "393859    2016-01-01 21:34:57\n",
       "393860    2016-01-01 21:35:04\n",
       "393861    2016-01-01 21:35:11\n",
       "393862    2016-01-01 21:35:18\n",
       "393863    2016-01-01 21:35:26\n",
       "393864    2016-01-01 21:35:33\n",
       "393865    2016-01-01 21:35:40\n",
       "393866    2016-01-01 21:35:47\n",
       "393867    2016-01-01 21:35:54\n",
       "393868    2016-01-01 21:36:01\n",
       "393869    2016-01-01 21:36:08\n",
       "393870    2016-01-01 21:36:15\n",
       "393871    2016-01-01 21:36:22\n",
       "393872    2016-01-01 21:36:29\n",
       "393873    2016-01-01 21:36:36\n",
       "393874    2016-01-01 21:36:43\n",
       "393875    2016-01-01 21:36:50\n",
       "393876    2016-01-01 21:36:57\n",
       "393877    2016-01-01 21:37:04\n",
       "393878    2016-01-01 21:37:11\n",
       "393879    2016-01-01 21:37:18\n",
       "393880    2016-01-01 21:37:25\n",
       "393881    2016-01-01 21:37:32\n",
       "393882    2016-01-01 21:37:39\n",
       "393883    2016-01-01 21:37:46\n",
       "393884    2016-01-01 21:37:53\n",
       "393885    2016-01-01 21:38:01\n",
       "Name: time, dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_15_df['time'][flag_15==3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "col_time = data_15_df['time'][flag_15==3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         2015-11-01 20:20:16\n",
       "1         2015-11-01 20:20:23\n",
       "2         2015-11-01 20:20:30\n",
       "3         2015-11-01 20:20:37\n",
       "4         2015-11-01 20:20:47\n",
       "5         2015-11-01 20:20:54\n",
       "6         2015-11-01 20:21:01\n",
       "7         2015-11-01 20:21:08\n",
       "8         2015-11-01 20:21:15\n",
       "9         2015-11-01 20:21:22\n",
       "10        2015-11-01 20:21:29\n",
       "11        2015-11-01 20:21:36\n",
       "12        2015-11-01 20:21:43\n",
       "13        2015-11-01 20:21:50\n",
       "14        2015-11-01 20:21:57\n",
       "15        2015-11-01 20:22:04\n",
       "16        2015-11-01 20:22:11\n",
       "17        2015-11-01 20:22:18\n",
       "18        2015-11-01 20:22:25\n",
       "19        2015-11-01 20:22:32\n",
       "20        2015-11-01 20:22:39\n",
       "21        2015-11-01 20:22:49\n",
       "22        2015-11-01 20:22:56\n",
       "23        2015-11-01 20:23:03\n",
       "24        2015-11-01 20:23:10\n",
       "25        2015-11-01 20:23:17\n",
       "26        2015-11-01 20:23:24\n",
       "27        2015-11-01 20:23:31\n",
       "28        2015-11-01 20:23:38\n",
       "29        2015-11-01 20:23:45\n",
       "                 ...         \n",
       "393856    2016-01-01 21:34:36\n",
       "393857    2016-01-01 21:34:43\n",
       "393858    2016-01-01 21:34:50\n",
       "393859    2016-01-01 21:34:57\n",
       "393860    2016-01-01 21:35:04\n",
       "393861    2016-01-01 21:35:11\n",
       "393862    2016-01-01 21:35:18\n",
       "393863    2016-01-01 21:35:26\n",
       "393864    2016-01-01 21:35:33\n",
       "393865    2016-01-01 21:35:40\n",
       "393866    2016-01-01 21:35:47\n",
       "393867    2016-01-01 21:35:54\n",
       "393868    2016-01-01 21:36:01\n",
       "393869    2016-01-01 21:36:08\n",
       "393870    2016-01-01 21:36:15\n",
       "393871    2016-01-01 21:36:22\n",
       "393872    2016-01-01 21:36:29\n",
       "393873    2016-01-01 21:36:36\n",
       "393874    2016-01-01 21:36:43\n",
       "393875    2016-01-01 21:36:50\n",
       "393876    2016-01-01 21:36:57\n",
       "393877    2016-01-01 21:37:04\n",
       "393878    2016-01-01 21:37:11\n",
       "393879    2016-01-01 21:37:18\n",
       "393880    2016-01-01 21:37:25\n",
       "393881    2016-01-01 21:37:32\n",
       "393882    2016-01-01 21:37:39\n",
       "393883    2016-01-01 21:37:46\n",
       "393884    2016-01-01 21:37:53\n",
       "393885    2016-01-01 21:38:01\n",
       "Name: time, dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "col_time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/baby/anaconda3/lib/python3.5/site-packages/ipykernel/__main__.py:2: FutureWarning: in the future, boolean array-likes will be handled as a boolean array index\n",
      "  from ipykernel import kernelapp as app\n",
      "/home/baby/anaconda3/lib/python3.5/site-packages/ipykernel/__main__.py:4: FutureWarning: in the future, boolean array-likes will be handled as a boolean array index\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "350255\n"
     ]
    }
   ],
   "source": [
    "col_tf = col_time.apply(addFlag1)\n",
    "flag_15[col_tf] = 1\n",
    "col_tf = col_time.apply(addFlag0)\n",
    "flag_15[col_tf] = 0\n",
    "print(sum(col_tf))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "350255"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum(col_tf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "np.save('flag15',flag_15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 0.,  0.,  3., ...,  3.,  3.,  3.])"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag_15"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2\n",
      "0\n",
      "393884\n"
     ]
    }
   ],
   "source": [
    "print(sum(flag_15==0))\n",
    "print(sum(flag_15==1))\n",
    "print(sum(flag_15==3))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          True\n",
       "1          True\n",
       "2          True\n",
       "3          True\n",
       "4          True\n",
       "5          True\n",
       "6          True\n",
       "7          True\n",
       "8          True\n",
       "9          True\n",
       "10         True\n",
       "11         True\n",
       "12         True\n",
       "13         True\n",
       "14         True\n",
       "15         True\n",
       "16         True\n",
       "17         True\n",
       "18         True\n",
       "19         True\n",
       "20         True\n",
       "21         True\n",
       "22         True\n",
       "23         True\n",
       "24         True\n",
       "25         True\n",
       "26         True\n",
       "27         True\n",
       "28         True\n",
       "29         True\n",
       "          ...  \n",
       "393856    False\n",
       "393857    False\n",
       "393858    False\n",
       "393859    False\n",
       "393860    False\n",
       "393861    False\n",
       "393862    False\n",
       "393863    False\n",
       "393864    False\n",
       "393865    False\n",
       "393866    False\n",
       "393867    False\n",
       "393868    False\n",
       "393869    False\n",
       "393870    False\n",
       "393871    False\n",
       "393872    False\n",
       "393873    False\n",
       "393874    False\n",
       "393875    False\n",
       "393876    False\n",
       "393877    False\n",
       "393878    False\n",
       "393879    False\n",
       "393880    False\n",
       "393881    False\n",
       "393882    False\n",
       "393883    False\n",
       "393884    False\n",
       "393885    False\n",
       "Name: time, dtype: bool"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "col_tf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "np.save('flag0',col_tf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.series.Series"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(col_tf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "flag1 = np.load('flag1.npy')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([False, False, False, ...,  True,  True,  True], dtype=bool)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "flag0 = np.load('flag0.npy')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ True,  True,  True, ..., False, False, False], dtype=bool)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "flag_15 = np.ones(data_15_df.shape[0])*3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "flag_15[flag1] = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 3.,  3.,  3., ...,  1.,  1.,  1.])"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag_15"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "23892"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum(flag_15==1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "flag_15[flag0] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 0.,  0.,  0., ...,  1.,  1.,  1.])"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flag_15"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "23892"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum(flag_15==1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "350255"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum(flag_15==0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "np.save('flag15.npy',flag_15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "flag15 = np.load('flag15.npy')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "23892"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum(flag15==1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "19739"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum(flag15==3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time</th>\n",
       "      <th>wind_speed</th>\n",
       "      <th>generator_speed</th>\n",
       "      <th>power</th>\n",
       "      <th>wind_direction</th>\n",
       "      <th>wind_direction_mean</th>\n",
       "      <th>yaw_position</th>\n",
       "      <th>yaw_speed</th>\n",
       "      <th>pitch1_angle</th>\n",
       "      <th>pitch2_angle</th>\n",
       "      <th>...</th>\n",
       "      <th>acc_y</th>\n",
       "      <th>environment_tmp</th>\n",
       "      <th>int_tmp</th>\n",
       "      <th>pitch1_ng5_tmp</th>\n",
       "      <th>pitch2_ng5_tmp</th>\n",
       "      <th>pitch3_ng5_tmp</th>\n",
       "      <th>pitch1_ng5_DC</th>\n",
       "      <th>pitch2_ng5_DC</th>\n",
       "      <th>pitch3_ng5_DC</th>\n",
       "      <th>group</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-11-01 20:20:16</td>\n",
       "      <td>1.859993</td>\n",
       "      <td>1.223595</td>\n",
       "      <td>2.515790</td>\n",
       "      <td>-2.072739</td>\n",
       "      <td>-2.073627</td>\n",
       "      <td>-0.655343</td>\n",
       "      <td>0.030804</td>\n",
       "      <td>0.555556</td>\n",
       "      <td>0.506667</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.403919</td>\n",
       "      <td>0.014918</td>\n",
       "      <td>1.307692</td>\n",
       "      <td>1.123077</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>1.36</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.56</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-11-01 20:20:23</td>\n",
       "      <td>1.911625</td>\n",
       "      <td>1.293394</td>\n",
       "      <td>2.313551</td>\n",
       "      <td>-2.010591</td>\n",
       "      <td>-1.615140</td>\n",
       "      <td>-0.655343</td>\n",
       "      <td>0.030804</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>0.133333</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-0.421277</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.307692</td>\n",
       "      <td>1.123077</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>0.44</td>\n",
       "      <td>2.88</td>\n",
       "      <td>-2.60</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2015-11-01 20:20:30</td>\n",
       "      <td>1.635027</td>\n",
       "      <td>1.280099</td>\n",
       "      <td>2.507799</td>\n",
       "      <td>-2.053750</td>\n",
       "      <td>-0.282742</td>\n",
       "      <td>-0.649566</td>\n",
       "      <td>0.170338</td>\n",
       "      <td>0.964444</td>\n",
       "      <td>0.951111</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.421277</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.307692</td>\n",
       "      <td>1.123077</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>1.76</td>\n",
       "      <td>0.60</td>\n",
       "      <td>2.56</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-11-01 20:20:37</td>\n",
       "      <td>1.786234</td>\n",
       "      <td>1.280099</td>\n",
       "      <td>2.349593</td>\n",
       "      <td>-2.007138</td>\n",
       "      <td>-2.234477</td>\n",
       "      <td>-0.655343</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.168889</td>\n",
       "      <td>0.137778</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.403919</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.307692</td>\n",
       "      <td>1.123077</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>2.80</td>\n",
       "      <td>-0.48</td>\n",
       "      <td>0.12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-11-01 20:20:47</td>\n",
       "      <td>1.786234</td>\n",
       "      <td>1.263480</td>\n",
       "      <td>2.321566</td>\n",
       "      <td>-2.264365</td>\n",
       "      <td>-1.428959</td>\n",
       "      <td>-0.637917</td>\n",
       "      <td>0.414524</td>\n",
       "      <td>0.182222</td>\n",
       "      <td>0.168889</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-0.403919</td>\n",
       "      <td>0.014918</td>\n",
       "      <td>1.307692</td>\n",
       "      <td>1.123077</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>-0.88</td>\n",
       "      <td>1.72</td>\n",
       "      <td>0.92</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2015-11-01 20:20:54</td>\n",
       "      <td>2.022264</td>\n",
       "      <td>1.286747</td>\n",
       "      <td>2.389643</td>\n",
       "      <td>-2.178047</td>\n",
       "      <td>-0.793157</td>\n",
       "      <td>-0.626269</td>\n",
       "      <td>0.623827</td>\n",
       "      <td>0.182222</td>\n",
       "      <td>0.168889</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.403919</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.307692</td>\n",
       "      <td>1.106154</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>0.20</td>\n",
       "      <td>-0.92</td>\n",
       "      <td>-1.48</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2015-11-01 20:21:01</td>\n",
       "      <td>2.202974</td>\n",
       "      <td>1.280099</td>\n",
       "      <td>2.455728</td>\n",
       "      <td>-1.825870</td>\n",
       "      <td>-0.020569</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>1.077315</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.177778</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.403919</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.307692</td>\n",
       "      <td>1.106154</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>-0.80</td>\n",
       "      <td>-1.76</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2015-11-01 20:21:08</td>\n",
       "      <td>2.298861</td>\n",
       "      <td>1.416375</td>\n",
       "      <td>2.483755</td>\n",
       "      <td>-1.295879</td>\n",
       "      <td>0.868540</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>0.833129</td>\n",
       "      <td>3.991111</td>\n",
       "      <td>3.968889</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.403919</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.307692</td>\n",
       "      <td>1.106154</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>-0.76</td>\n",
       "      <td>-0.92</td>\n",
       "      <td>1.12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2015-11-01 20:21:15</td>\n",
       "      <td>2.608650</td>\n",
       "      <td>1.256833</td>\n",
       "      <td>2.503791</td>\n",
       "      <td>-1.009304</td>\n",
       "      <td>0.344194</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>0.623827</td>\n",
       "      <td>3.253333</td>\n",
       "      <td>3.226667</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-0.403919</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.307692</td>\n",
       "      <td>1.106154</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>0.64</td>\n",
       "      <td>1.32</td>\n",
       "      <td>0.36</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2015-11-01 20:21:22</td>\n",
       "      <td>2.523827</td>\n",
       "      <td>1.256833</td>\n",
       "      <td>2.507799</td>\n",
       "      <td>-0.496576</td>\n",
       "      <td>1.055988</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>0.484292</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>2.622222</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-0.389716</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.307692</td>\n",
       "      <td>1.106154</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2015-11-01 20:21:29</td>\n",
       "      <td>2.391060</td>\n",
       "      <td>1.243537</td>\n",
       "      <td>2.513798</td>\n",
       "      <td>0.009247</td>\n",
       "      <td>1.833642</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>0.344757</td>\n",
       "      <td>2.657778</td>\n",
       "      <td>2.640000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.389716</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.307692</td>\n",
       "      <td>1.106154</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>2.80</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2015-11-01 20:21:36</td>\n",
       "      <td>2.103399</td>\n",
       "      <td>1.236890</td>\n",
       "      <td>2.515790</td>\n",
       "      <td>0.311359</td>\n",
       "      <td>1.689257</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>0.240106</td>\n",
       "      <td>2.031111</td>\n",
       "      <td>1.982222</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.389716</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.307692</td>\n",
       "      <td>1.106154</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>0.08</td>\n",
       "      <td>-0.64</td>\n",
       "      <td>-2.68</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2015-11-01 20:21:43</td>\n",
       "      <td>2.254606</td>\n",
       "      <td>1.243537</td>\n",
       "      <td>2.511806</td>\n",
       "      <td>0.463279</td>\n",
       "      <td>0.848276</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>0.170338</td>\n",
       "      <td>2.124444</td>\n",
       "      <td>2.084444</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.389716</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.290769</td>\n",
       "      <td>1.106154</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>0.12</td>\n",
       "      <td>-3.28</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2015-11-01 20:21:50</td>\n",
       "      <td>2.000136</td>\n",
       "      <td>1.157118</td>\n",
       "      <td>2.485770</td>\n",
       "      <td>0.420120</td>\n",
       "      <td>-0.309340</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>0.135455</td>\n",
       "      <td>0.511111</td>\n",
       "      <td>0.484444</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.389716</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.290769</td>\n",
       "      <td>1.090769</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>0.72</td>\n",
       "      <td>-1.56</td>\n",
       "      <td>1.32</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2015-11-01 20:21:57</td>\n",
       "      <td>1.812050</td>\n",
       "      <td>1.343252</td>\n",
       "      <td>2.339587</td>\n",
       "      <td>0.504711</td>\n",
       "      <td>0.317596</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>0.100571</td>\n",
       "      <td>0.164444</td>\n",
       "      <td>0.137778</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.389716</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.290769</td>\n",
       "      <td>1.090769</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>-0.92</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>-1.68</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2015-11-01 20:22:04</td>\n",
       "      <td>2.328365</td>\n",
       "      <td>1.323309</td>\n",
       "      <td>2.487762</td>\n",
       "      <td>0.682526</td>\n",
       "      <td>1.986893</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>0.065687</td>\n",
       "      <td>2.528889</td>\n",
       "      <td>2.502222</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.403919</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.290769</td>\n",
       "      <td>1.090769</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>0.64</td>\n",
       "      <td>-2.72</td>\n",
       "      <td>2.12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2015-11-01 20:22:11</td>\n",
       "      <td>2.379997</td>\n",
       "      <td>1.280099</td>\n",
       "      <td>2.503791</td>\n",
       "      <td>0.884510</td>\n",
       "      <td>0.896404</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>0.030804</td>\n",
       "      <td>3.391111</td>\n",
       "      <td>3.364444</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.389716</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.290769</td>\n",
       "      <td>1.090769</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>-1.56</td>\n",
       "      <td>1.68</td>\n",
       "      <td>2.80</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2015-11-01 20:22:18</td>\n",
       "      <td>2.582835</td>\n",
       "      <td>1.200328</td>\n",
       "      <td>2.503791</td>\n",
       "      <td>0.812003</td>\n",
       "      <td>-0.045900</td>\n",
       "      <td>-0.585499</td>\n",
       "      <td>0.205222</td>\n",
       "      <td>2.511111</td>\n",
       "      <td>2.457778</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.403919</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.290769</td>\n",
       "      <td>1.090769</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>1.08</td>\n",
       "      <td>0.76</td>\n",
       "      <td>0.32</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2015-11-01 20:22:25</td>\n",
       "      <td>2.184534</td>\n",
       "      <td>1.263480</td>\n",
       "      <td>2.517805</td>\n",
       "      <td>0.938027</td>\n",
       "      <td>1.627196</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>2.337778</td>\n",
       "      <td>2.306667</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.403919</td>\n",
       "      <td>-0.023326</td>\n",
       "      <td>1.290769</td>\n",
       "      <td>1.090769</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>1.44</td>\n",
       "      <td>2.40</td>\n",
       "      <td>2.60</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2015-11-01 20:22:32</td>\n",
       "      <td>2.354181</td>\n",
       "      <td>1.223595</td>\n",
       "      <td>2.505783</td>\n",
       "      <td>1.129652</td>\n",
       "      <td>1.528406</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>2.195556</td>\n",
       "      <td>2.151111</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.421277</td>\n",
       "      <td>-0.023326</td>\n",
       "      <td>1.276923</td>\n",
       "      <td>1.090769</td>\n",
       "      <td>0.769231</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1.36</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2015-11-01 20:22:39</td>\n",
       "      <td>2.324677</td>\n",
       "      <td>1.300042</td>\n",
       "      <td>2.513798</td>\n",
       "      <td>1.164179</td>\n",
       "      <td>1.011659</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>2.528889</td>\n",
       "      <td>2.528889</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-0.421277</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.276923</td>\n",
       "      <td>1.090769</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.48</td>\n",
       "      <td>-1.88</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2015-11-01 20:22:49</td>\n",
       "      <td>2.549643</td>\n",
       "      <td>1.293394</td>\n",
       "      <td>2.507799</td>\n",
       "      <td>0.998449</td>\n",
       "      <td>0.284666</td>\n",
       "      <td>-0.585499</td>\n",
       "      <td>0.170338</td>\n",
       "      <td>3.235556</td>\n",
       "      <td>3.204444</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.421277</td>\n",
       "      <td>-0.023326</td>\n",
       "      <td>1.276923</td>\n",
       "      <td>1.076923</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>0.72</td>\n",
       "      <td>-0.24</td>\n",
       "      <td>1.72</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2015-11-01 20:22:56</td>\n",
       "      <td>2.586523</td>\n",
       "      <td>1.280099</td>\n",
       "      <td>2.507799</td>\n",
       "      <td>0.931121</td>\n",
       "      <td>0.139015</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>3.102222</td>\n",
       "      <td>3.048889</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.452839</td>\n",
       "      <td>-0.023326</td>\n",
       "      <td>1.276923</td>\n",
       "      <td>1.076923</td>\n",
       "      <td>0.769231</td>\n",
       "      <td>-1.56</td>\n",
       "      <td>-0.72</td>\n",
       "      <td>2.76</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2015-11-01 20:23:03</td>\n",
       "      <td>2.306237</td>\n",
       "      <td>1.187033</td>\n",
       "      <td>2.507799</td>\n",
       "      <td>0.910405</td>\n",
       "      <td>0.046557</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>2.568889</td>\n",
       "      <td>2.537778</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-0.452839</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.276923</td>\n",
       "      <td>1.076923</td>\n",
       "      <td>0.769231</td>\n",
       "      <td>0.16</td>\n",
       "      <td>2.64</td>\n",
       "      <td>-0.76</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2015-11-01 20:23:10</td>\n",
       "      <td>2.402124</td>\n",
       "      <td>1.243537</td>\n",
       "      <td>2.503791</td>\n",
       "      <td>0.894868</td>\n",
       "      <td>0.106085</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>2.466667</td>\n",
       "      <td>2.457778</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-0.437058</td>\n",
       "      <td>-0.023326</td>\n",
       "      <td>1.276923</td>\n",
       "      <td>1.076923</td>\n",
       "      <td>0.769231</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.28</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2015-11-01 20:23:17</td>\n",
       "      <td>2.379997</td>\n",
       "      <td>1.300042</td>\n",
       "      <td>2.521812</td>\n",
       "      <td>0.768844</td>\n",
       "      <td>1.172509</td>\n",
       "      <td>-0.585499</td>\n",
       "      <td>0.170338</td>\n",
       "      <td>1.582222</td>\n",
       "      <td>1.555556</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-0.421277</td>\n",
       "      <td>-0.002291</td>\n",
       "      <td>1.276923</td>\n",
       "      <td>1.076923</td>\n",
       "      <td>0.769231</td>\n",
       "      <td>2.92</td>\n",
       "      <td>0.20</td>\n",
       "      <td>2.56</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2015-11-01 20:23:24</td>\n",
       "      <td>2.214038</td>\n",
       "      <td>1.286747</td>\n",
       "      <td>2.497769</td>\n",
       "      <td>0.699789</td>\n",
       "      <td>-0.033234</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>2.631111</td>\n",
       "      <td>2.586667</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.437058</td>\n",
       "      <td>-0.023326</td>\n",
       "      <td>1.276923</td>\n",
       "      <td>1.076923</td>\n",
       "      <td>0.769231</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2015-11-01 20:23:31</td>\n",
       "      <td>2.579147</td>\n",
       "      <td>1.300042</td>\n",
       "      <td>2.503791</td>\n",
       "      <td>0.730864</td>\n",
       "      <td>0.207408</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>2.448889</td>\n",
       "      <td>2.444444</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-0.437058</td>\n",
       "      <td>-0.023326</td>\n",
       "      <td>1.276923</td>\n",
       "      <td>1.076923</td>\n",
       "      <td>0.769231</td>\n",
       "      <td>1.84</td>\n",
       "      <td>-1.08</td>\n",
       "      <td>0.36</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2015-11-01 20:23:38</td>\n",
       "      <td>2.475884</td>\n",
       "      <td>1.230242</td>\n",
       "      <td>2.517805</td>\n",
       "      <td>0.722232</td>\n",
       "      <td>0.602567</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>2.204444</td>\n",
       "      <td>2.151111</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.437058</td>\n",
       "      <td>-0.023326</td>\n",
       "      <td>1.276923</td>\n",
       "      <td>1.061538</td>\n",
       "      <td>0.769231</td>\n",
       "      <td>0.80</td>\n",
       "      <td>1.32</td>\n",
       "      <td>-1.20</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2015-11-01 20:23:45</td>\n",
       "      <td>2.140279</td>\n",
       "      <td>1.170414</td>\n",
       "      <td>2.485770</td>\n",
       "      <td>0.654904</td>\n",
       "      <td>0.901470</td>\n",
       "      <td>-0.591323</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>1.151111</td>\n",
       "      <td>1.120000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-0.421277</td>\n",
       "      <td>-0.023326</td>\n",
       "      <td>1.260000</td>\n",
       "      <td>1.061538</td>\n",
       "      <td>0.769231</td>\n",
       "      <td>0.20</td>\n",
       "      <td>1.92</td>\n",
       "      <td>0.12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393856</th>\n",
       "      <td>2016-01-01 21:34:36</td>\n",
       "      <td>0.130337</td>\n",
       "      <td>-1.186164</td>\n",
       "      <td>-0.889148</td>\n",
       "      <td>0.461552</td>\n",
       "      <td>0.008561</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-1.587465</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>0.815385</td>\n",
       "      <td>1.061538</td>\n",
       "      <td>1.72</td>\n",
       "      <td>0.12</td>\n",
       "      <td>-0.44</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393857</th>\n",
       "      <td>2016-01-01 21:34:43</td>\n",
       "      <td>-0.275339</td>\n",
       "      <td>-1.179516</td>\n",
       "      <td>-0.895147</td>\n",
       "      <td>0.373508</td>\n",
       "      <td>1.014192</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.480153</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.783077</td>\n",
       "      <td>0.815385</td>\n",
       "      <td>1.061538</td>\n",
       "      <td>-0.88</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>0.04</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393858</th>\n",
       "      <td>2016-01-01 21:34:50</td>\n",
       "      <td>-0.109381</td>\n",
       "      <td>-1.136307</td>\n",
       "      <td>-0.903162</td>\n",
       "      <td>0.603114</td>\n",
       "      <td>1.386554</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.815385</td>\n",
       "      <td>0.815385</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.52</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393859</th>\n",
       "      <td>2016-01-01 21:34:57</td>\n",
       "      <td>-0.470801</td>\n",
       "      <td>-1.129659</td>\n",
       "      <td>-0.895147</td>\n",
       "      <td>0.908679</td>\n",
       "      <td>1.473945</td>\n",
       "      <td>-0.725234</td>\n",
       "      <td>0.135455</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.815385</td>\n",
       "      <td>0.830769</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>-0.52</td>\n",
       "      <td>-0.52</td>\n",
       "      <td>-0.40</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393860</th>\n",
       "      <td>2016-01-01 21:35:04</td>\n",
       "      <td>0.392183</td>\n",
       "      <td>-1.149602</td>\n",
       "      <td>-0.865105</td>\n",
       "      <td>0.822361</td>\n",
       "      <td>-0.368867</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.815385</td>\n",
       "      <td>0.846154</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>1.84</td>\n",
       "      <td>1.32</td>\n",
       "      <td>0.28</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393861</th>\n",
       "      <td>2016-01-01 21:35:11</td>\n",
       "      <td>0.163529</td>\n",
       "      <td>-1.136307</td>\n",
       "      <td>-0.845092</td>\n",
       "      <td>0.739496</td>\n",
       "      <td>0.814079</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.830769</td>\n",
       "      <td>0.846154</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.24</td>\n",
       "      <td>-1.08</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393862</th>\n",
       "      <td>2016-01-01 21:35:18</td>\n",
       "      <td>0.425374</td>\n",
       "      <td>-1.186164</td>\n",
       "      <td>-0.849099</td>\n",
       "      <td>0.611745</td>\n",
       "      <td>-0.884348</td>\n",
       "      <td>-0.719410</td>\n",
       "      <td>0.309873</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.846154</td>\n",
       "      <td>0.846154</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>-0.56</td>\n",
       "      <td>-0.76</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393863</th>\n",
       "      <td>2016-01-01 21:35:26</td>\n",
       "      <td>-0.297467</td>\n",
       "      <td>-1.202783</td>\n",
       "      <td>-0.915184</td>\n",
       "      <td>0.235400</td>\n",
       "      <td>-1.786123</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.846154</td>\n",
       "      <td>0.860000</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>-0.56</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.60</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393864</th>\n",
       "      <td>2016-01-01 21:35:33</td>\n",
       "      <td>-0.006118</td>\n",
       "      <td>-1.123012</td>\n",
       "      <td>-0.879142</td>\n",
       "      <td>-0.083976</td>\n",
       "      <td>-0.980605</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.038964</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.480153</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.846154</td>\n",
       "      <td>0.860000</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>-0.64</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>-1.12</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393865</th>\n",
       "      <td>2016-01-01 21:35:40</td>\n",
       "      <td>0.233600</td>\n",
       "      <td>-1.159574</td>\n",
       "      <td>-0.859105</td>\n",
       "      <td>-0.225538</td>\n",
       "      <td>1.605665</td>\n",
       "      <td>-0.725234</td>\n",
       "      <td>0.135455</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.860000</td>\n",
       "      <td>0.875385</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.80</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393866</th>\n",
       "      <td>2016-01-01 21:35:47</td>\n",
       "      <td>-0.094629</td>\n",
       "      <td>-1.186164</td>\n",
       "      <td>-0.877126</td>\n",
       "      <td>0.180156</td>\n",
       "      <td>0.621565</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.686936</td>\n",
       "      <td>0.860000</td>\n",
       "      <td>0.892308</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>0.64</td>\n",
       "      <td>-0.24</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393867</th>\n",
       "      <td>2016-01-01 21:35:54</td>\n",
       "      <td>-0.205268</td>\n",
       "      <td>-1.149602</td>\n",
       "      <td>-0.899155</td>\n",
       "      <td>0.023058</td>\n",
       "      <td>1.163644</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.875385</td>\n",
       "      <td>0.907692</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>-0.64</td>\n",
       "      <td>0.36</td>\n",
       "      <td>-1.48</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393868</th>\n",
       "      <td>2016-01-01 21:36:01</td>\n",
       "      <td>-0.297467</td>\n",
       "      <td>-1.129659</td>\n",
       "      <td>-0.871127</td>\n",
       "      <td>-0.018375</td>\n",
       "      <td>-0.636106</td>\n",
       "      <td>-0.736835</td>\n",
       "      <td>-0.178499</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.892308</td>\n",
       "      <td>0.907692</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>-0.68</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.52</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393869</th>\n",
       "      <td>2016-01-01 21:36:08</td>\n",
       "      <td>0.181969</td>\n",
       "      <td>-1.159574</td>\n",
       "      <td>-0.847084</td>\n",
       "      <td>-0.208274</td>\n",
       "      <td>-0.280209</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.892308</td>\n",
       "      <td>0.923077</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>-0.56</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>1.92</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393870</th>\n",
       "      <td>2016-01-01 21:36:15</td>\n",
       "      <td>0.038138</td>\n",
       "      <td>-1.199459</td>\n",
       "      <td>-0.873119</td>\n",
       "      <td>-0.353288</td>\n",
       "      <td>-1.428959</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>1.331741</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.892308</td>\n",
       "      <td>0.923077</td>\n",
       "      <td>1.029231</td>\n",
       "      <td>1.76</td>\n",
       "      <td>0.12</td>\n",
       "      <td>0.08</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393871</th>\n",
       "      <td>2016-01-01 21:36:22</td>\n",
       "      <td>0.266792</td>\n",
       "      <td>-1.166221</td>\n",
       "      <td>-0.883126</td>\n",
       "      <td>-0.531103</td>\n",
       "      <td>0.215007</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.907692</td>\n",
       "      <td>0.936923</td>\n",
       "      <td>1.029231</td>\n",
       "      <td>-0.44</td>\n",
       "      <td>0.76</td>\n",
       "      <td>-0.08</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393872</th>\n",
       "      <td>2016-01-01 21:36:29</td>\n",
       "      <td>0.406935</td>\n",
       "      <td>-1.149602</td>\n",
       "      <td>-0.861097</td>\n",
       "      <td>-0.370552</td>\n",
       "      <td>0.570904</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.923077</td>\n",
       "      <td>0.936923</td>\n",
       "      <td>1.029231</td>\n",
       "      <td>0.84</td>\n",
       "      <td>0.20</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393873</th>\n",
       "      <td>2016-01-01 21:36:36</td>\n",
       "      <td>-0.031933</td>\n",
       "      <td>-1.152926</td>\n",
       "      <td>-0.849099</td>\n",
       "      <td>-0.279055</td>\n",
       "      <td>-0.608243</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.923077</td>\n",
       "      <td>0.936923</td>\n",
       "      <td>1.029231</td>\n",
       "      <td>0.52</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>1.44</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393874</th>\n",
       "      <td>2016-01-01 21:36:43</td>\n",
       "      <td>0.148777</td>\n",
       "      <td>-1.166221</td>\n",
       "      <td>-0.849099</td>\n",
       "      <td>-0.475859</td>\n",
       "      <td>-0.815955</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.936923</td>\n",
       "      <td>0.952308</td>\n",
       "      <td>1.013846</td>\n",
       "      <td>-0.56</td>\n",
       "      <td>1.72</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393875</th>\n",
       "      <td>2016-01-01 21:36:50</td>\n",
       "      <td>0.200408</td>\n",
       "      <td>-1.149602</td>\n",
       "      <td>-0.837077</td>\n",
       "      <td>-0.632958</td>\n",
       "      <td>-1.192116</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.686936</td>\n",
       "      <td>0.936923</td>\n",
       "      <td>0.969231</td>\n",
       "      <td>1.013846</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.32</td>\n",
       "      <td>-0.76</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393876</th>\n",
       "      <td>2016-01-01 21:36:57</td>\n",
       "      <td>-0.113069</td>\n",
       "      <td>-1.186164</td>\n",
       "      <td>-0.847084</td>\n",
       "      <td>-0.449964</td>\n",
       "      <td>1.400486</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.686936</td>\n",
       "      <td>0.936923</td>\n",
       "      <td>0.969231</td>\n",
       "      <td>1.013846</td>\n",
       "      <td>1.88</td>\n",
       "      <td>0.24</td>\n",
       "      <td>-1.12</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393877</th>\n",
       "      <td>2016-01-01 21:37:04</td>\n",
       "      <td>-0.433922</td>\n",
       "      <td>-1.199459</td>\n",
       "      <td>-0.913168</td>\n",
       "      <td>-0.367099</td>\n",
       "      <td>-0.344803</td>\n",
       "      <td>-0.725234</td>\n",
       "      <td>0.135455</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.686936</td>\n",
       "      <td>0.952308</td>\n",
       "      <td>0.984615</td>\n",
       "      <td>1.013846</td>\n",
       "      <td>-0.76</td>\n",
       "      <td>-1.56</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393878</th>\n",
       "      <td>2016-01-01 21:37:11</td>\n",
       "      <td>-0.533497</td>\n",
       "      <td>-1.152926</td>\n",
       "      <td>-0.893156</td>\n",
       "      <td>-0.078797</td>\n",
       "      <td>0.536707</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.620604</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.969231</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.013846</td>\n",
       "      <td>-0.76</td>\n",
       "      <td>1.36</td>\n",
       "      <td>1.36</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393879</th>\n",
       "      <td>2016-01-01 21:37:18</td>\n",
       "      <td>-0.419170</td>\n",
       "      <td>-1.149602</td>\n",
       "      <td>-0.887133</td>\n",
       "      <td>0.031689</td>\n",
       "      <td>-0.299207</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.004080</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.969231</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.36</td>\n",
       "      <td>0.28</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393880</th>\n",
       "      <td>2016-01-01 21:37:25</td>\n",
       "      <td>-0.474489</td>\n",
       "      <td>-1.123012</td>\n",
       "      <td>-0.863113</td>\n",
       "      <td>0.042048</td>\n",
       "      <td>-0.009170</td>\n",
       "      <td>-0.684464</td>\n",
       "      <td>0.309873</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.604824</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>0.984615</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.24</td>\n",
       "      <td>1.32</td>\n",
       "      <td>-0.40</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393881</th>\n",
       "      <td>2016-01-01 21:37:32</td>\n",
       "      <td>-0.113069</td>\n",
       "      <td>-1.179516</td>\n",
       "      <td>-0.883126</td>\n",
       "      <td>0.033416</td>\n",
       "      <td>0.826745</td>\n",
       "      <td>-0.742660</td>\n",
       "      <td>-0.527336</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.620604</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.013846</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.52</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>-1.48</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393882</th>\n",
       "      <td>2016-01-01 21:37:39</td>\n",
       "      <td>0.034450</td>\n",
       "      <td>-1.136307</td>\n",
       "      <td>-0.871127</td>\n",
       "      <td>0.145629</td>\n",
       "      <td>0.330262</td>\n",
       "      <td>-0.742660</td>\n",
       "      <td>-0.457568</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.620604</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.013846</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-2.36</td>\n",
       "      <td>1.84</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393883</th>\n",
       "      <td>2016-01-01 21:37:46</td>\n",
       "      <td>0.292608</td>\n",
       "      <td>-1.129659</td>\n",
       "      <td>-0.877126</td>\n",
       "      <td>-0.085703</td>\n",
       "      <td>-1.540414</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.073848</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.209522</td>\n",
       "      <td>-1.620604</td>\n",
       "      <td>-1.686936</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.013846</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.20</td>\n",
       "      <td>0.12</td>\n",
       "      <td>1.28</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393884</th>\n",
       "      <td>2016-01-01 21:37:53</td>\n",
       "      <td>-0.035621</td>\n",
       "      <td>-1.159574</td>\n",
       "      <td>-0.877126</td>\n",
       "      <td>-0.622600</td>\n",
       "      <td>-1.442891</td>\n",
       "      <td>-0.731058</td>\n",
       "      <td>-0.073848</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.620604</td>\n",
       "      <td>-1.665902</td>\n",
       "      <td>1.013846</td>\n",
       "      <td>1.029231</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.76</td>\n",
       "      <td>-0.40</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393885</th>\n",
       "      <td>2016-01-01 21:38:01</td>\n",
       "      <td>0.226224</td>\n",
       "      <td>-1.166221</td>\n",
       "      <td>-0.863113</td>\n",
       "      <td>-0.803867</td>\n",
       "      <td>-0.487921</td>\n",
       "      <td>-0.725234</td>\n",
       "      <td>0.100571</td>\n",
       "      <td>0.204444</td>\n",
       "      <td>0.195556</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061109</td>\n",
       "      <td>-1.636385</td>\n",
       "      <td>-1.686936</td>\n",
       "      <td>1.013846</td>\n",
       "      <td>1.046154</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>1.52</td>\n",
       "      <td>0.60</td>\n",
       "      <td>3853</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>393886 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       time  wind_speed  generator_speed     power  \\\n",
       "0       2015-11-01 20:20:16    1.859993         1.223595  2.515790   \n",
       "1       2015-11-01 20:20:23    1.911625         1.293394  2.313551   \n",
       "2       2015-11-01 20:20:30    1.635027         1.280099  2.507799   \n",
       "3       2015-11-01 20:20:37    1.786234         1.280099  2.349593   \n",
       "4       2015-11-01 20:20:47    1.786234         1.263480  2.321566   \n",
       "5       2015-11-01 20:20:54    2.022264         1.286747  2.389643   \n",
       "6       2015-11-01 20:21:01    2.202974         1.280099  2.455728   \n",
       "7       2015-11-01 20:21:08    2.298861         1.416375  2.483755   \n",
       "8       2015-11-01 20:21:15    2.608650         1.256833  2.503791   \n",
       "9       2015-11-01 20:21:22    2.523827         1.256833  2.507799   \n",
       "10      2015-11-01 20:21:29    2.391060         1.243537  2.513798   \n",
       "11      2015-11-01 20:21:36    2.103399         1.236890  2.515790   \n",
       "12      2015-11-01 20:21:43    2.254606         1.243537  2.511806   \n",
       "13      2015-11-01 20:21:50    2.000136         1.157118  2.485770   \n",
       "14      2015-11-01 20:21:57    1.812050         1.343252  2.339587   \n",
       "15      2015-11-01 20:22:04    2.328365         1.323309  2.487762   \n",
       "16      2015-11-01 20:22:11    2.379997         1.280099  2.503791   \n",
       "17      2015-11-01 20:22:18    2.582835         1.200328  2.503791   \n",
       "18      2015-11-01 20:22:25    2.184534         1.263480  2.517805   \n",
       "19      2015-11-01 20:22:32    2.354181         1.223595  2.505783   \n",
       "20      2015-11-01 20:22:39    2.324677         1.300042  2.513798   \n",
       "21      2015-11-01 20:22:49    2.549643         1.293394  2.507799   \n",
       "22      2015-11-01 20:22:56    2.586523         1.280099  2.507799   \n",
       "23      2015-11-01 20:23:03    2.306237         1.187033  2.507799   \n",
       "24      2015-11-01 20:23:10    2.402124         1.243537  2.503791   \n",
       "25      2015-11-01 20:23:17    2.379997         1.300042  2.521812   \n",
       "26      2015-11-01 20:23:24    2.214038         1.286747  2.497769   \n",
       "27      2015-11-01 20:23:31    2.579147         1.300042  2.503791   \n",
       "28      2015-11-01 20:23:38    2.475884         1.230242  2.517805   \n",
       "29      2015-11-01 20:23:45    2.140279         1.170414  2.485770   \n",
       "...                     ...         ...              ...       ...   \n",
       "393856  2016-01-01 21:34:36    0.130337        -1.186164 -0.889148   \n",
       "393857  2016-01-01 21:34:43   -0.275339        -1.179516 -0.895147   \n",
       "393858  2016-01-01 21:34:50   -0.109381        -1.136307 -0.903162   \n",
       "393859  2016-01-01 21:34:57   -0.470801        -1.129659 -0.895147   \n",
       "393860  2016-01-01 21:35:04    0.392183        -1.149602 -0.865105   \n",
       "393861  2016-01-01 21:35:11    0.163529        -1.136307 -0.845092   \n",
       "393862  2016-01-01 21:35:18    0.425374        -1.186164 -0.849099   \n",
       "393863  2016-01-01 21:35:26   -0.297467        -1.202783 -0.915184   \n",
       "393864  2016-01-01 21:35:33   -0.006118        -1.123012 -0.879142   \n",
       "393865  2016-01-01 21:35:40    0.233600        -1.159574 -0.859105   \n",
       "393866  2016-01-01 21:35:47   -0.094629        -1.186164 -0.877126   \n",
       "393867  2016-01-01 21:35:54   -0.205268        -1.149602 -0.899155   \n",
       "393868  2016-01-01 21:36:01   -0.297467        -1.129659 -0.871127   \n",
       "393869  2016-01-01 21:36:08    0.181969        -1.159574 -0.847084   \n",
       "393870  2016-01-01 21:36:15    0.038138        -1.199459 -0.873119   \n",
       "393871  2016-01-01 21:36:22    0.266792        -1.166221 -0.883126   \n",
       "393872  2016-01-01 21:36:29    0.406935        -1.149602 -0.861097   \n",
       "393873  2016-01-01 21:36:36   -0.031933        -1.152926 -0.849099   \n",
       "393874  2016-01-01 21:36:43    0.148777        -1.166221 -0.849099   \n",
       "393875  2016-01-01 21:36:50    0.200408        -1.149602 -0.837077   \n",
       "393876  2016-01-01 21:36:57   -0.113069        -1.186164 -0.847084   \n",
       "393877  2016-01-01 21:37:04   -0.433922        -1.199459 -0.913168   \n",
       "393878  2016-01-01 21:37:11   -0.533497        -1.152926 -0.893156   \n",
       "393879  2016-01-01 21:37:18   -0.419170        -1.149602 -0.887133   \n",
       "393880  2016-01-01 21:37:25   -0.474489        -1.123012 -0.863113   \n",
       "393881  2016-01-01 21:37:32   -0.113069        -1.179516 -0.883126   \n",
       "393882  2016-01-01 21:37:39    0.034450        -1.136307 -0.871127   \n",
       "393883  2016-01-01 21:37:46    0.292608        -1.129659 -0.877126   \n",
       "393884  2016-01-01 21:37:53   -0.035621        -1.159574 -0.877126   \n",
       "393885  2016-01-01 21:38:01    0.226224        -1.166221 -0.863113   \n",
       "\n",
       "        wind_direction  wind_direction_mean  yaw_position  yaw_speed  \\\n",
       "0            -2.072739            -2.073627     -0.655343   0.030804   \n",
       "1            -2.010591            -1.615140     -0.655343   0.030804   \n",
       "2            -2.053750            -0.282742     -0.649566   0.170338   \n",
       "3            -2.007138            -2.234477     -0.655343  -0.004080   \n",
       "4            -2.264365            -1.428959     -0.637917   0.414524   \n",
       "5            -2.178047            -0.793157     -0.626269   0.623827   \n",
       "6            -1.825870            -0.020569     -0.591323   1.077315   \n",
       "7            -1.295879             0.868540     -0.591323   0.833129   \n",
       "8            -1.009304             0.344194     -0.591323   0.623827   \n",
       "9            -0.496576             1.055988     -0.591323   0.484292   \n",
       "10            0.009247             1.833642     -0.591323   0.344757   \n",
       "11            0.311359             1.689257     -0.591323   0.240106   \n",
       "12            0.463279             0.848276     -0.591323   0.170338   \n",
       "13            0.420120            -0.309340     -0.591323   0.135455   \n",
       "14            0.504711             0.317596     -0.591323   0.100571   \n",
       "15            0.682526             1.986893     -0.591323   0.065687   \n",
       "16            0.884510             0.896404     -0.591323   0.030804   \n",
       "17            0.812003            -0.045900     -0.585499   0.205222   \n",
       "18            0.938027             1.627196     -0.591323  -0.004080   \n",
       "19            1.129652             1.528406     -0.591323  -0.004080   \n",
       "20            1.164179             1.011659     -0.591323  -0.004080   \n",
       "21            0.998449             0.284666     -0.585499   0.170338   \n",
       "22            0.931121             0.139015     -0.591323  -0.004080   \n",
       "23            0.910405             0.046557     -0.591323  -0.004080   \n",
       "24            0.894868             0.106085     -0.591323  -0.004080   \n",
       "25            0.768844             1.172509     -0.585499   0.170338   \n",
       "26            0.699789            -0.033234     -0.591323  -0.004080   \n",
       "27            0.730864             0.207408     -0.591323  -0.004080   \n",
       "28            0.722232             0.602567     -0.591323  -0.004080   \n",
       "29            0.654904             0.901470     -0.591323  -0.004080   \n",
       "...                ...                  ...           ...        ...   \n",
       "393856        0.461552             0.008561     -0.731058  -0.004080   \n",
       "393857        0.373508             1.014192     -0.731058  -0.004080   \n",
       "393858        0.603114             1.386554     -0.731058  -0.004080   \n",
       "393859        0.908679             1.473945     -0.725234   0.135455   \n",
       "393860        0.822361            -0.368867     -0.731058  -0.004080   \n",
       "393861        0.739496             0.814079     -0.731058  -0.004080   \n",
       "393862        0.611745            -0.884348     -0.719410   0.309873   \n",
       "393863        0.235400            -1.786123     -0.731058  -0.004080   \n",
       "393864       -0.083976            -0.980605     -0.731058  -0.038964   \n",
       "393865       -0.225538             1.605665     -0.725234   0.135455   \n",
       "393866        0.180156             0.621565     -0.731058  -0.004080   \n",
       "393867        0.023058             1.163644     -0.731058  -0.004080   \n",
       "393868       -0.018375            -0.636106     -0.736835  -0.178499   \n",
       "393869       -0.208274            -0.280209     -0.731058  -0.004080   \n",
       "393870       -0.353288            -1.428959     -0.731058  -0.004080   \n",
       "393871       -0.531103             0.215007     -0.731058  -0.004080   \n",
       "393872       -0.370552             0.570904     -0.731058  -0.004080   \n",
       "393873       -0.279055            -0.608243     -0.731058  -0.004080   \n",
       "393874       -0.475859            -0.815955     -0.731058  -0.004080   \n",
       "393875       -0.632958            -1.192116     -0.731058  -0.004080   \n",
       "393876       -0.449964             1.400486     -0.731058  -0.004080   \n",
       "393877       -0.367099            -0.344803     -0.725234   0.135455   \n",
       "393878       -0.078797             0.536707     -0.731058  -0.004080   \n",
       "393879        0.031689            -0.299207     -0.731058  -0.004080   \n",
       "393880        0.042048            -0.009170     -0.684464   0.309873   \n",
       "393881        0.033416             0.826745     -0.742660  -0.527336   \n",
       "393882        0.145629             0.330262     -0.742660  -0.457568   \n",
       "393883       -0.085703            -1.540414     -0.731058  -0.073848   \n",
       "393884       -0.622600            -1.442891     -0.731058  -0.073848   \n",
       "393885       -0.803867            -0.487921     -0.725234   0.100571   \n",
       "\n",
       "        pitch1_angle  pitch2_angle  ...       acc_y  environment_tmp  \\\n",
       "0           0.555556      0.506667  ...    0.061109        -0.403919   \n",
       "1           0.195556      0.133333  ...   -1.209522        -0.421277   \n",
       "2           0.964444      0.951111  ...    0.061109        -0.421277   \n",
       "3           0.168889      0.137778  ...    0.061109        -0.403919   \n",
       "4           0.182222      0.168889  ...   -1.209522        -0.403919   \n",
       "5           0.182222      0.168889  ...    0.061109        -0.403919   \n",
       "6           0.204444      0.177778  ...    0.061109        -0.403919   \n",
       "7           3.991111      3.968889  ...    0.061109        -0.403919   \n",
       "8           3.253333      3.226667  ...   -1.209522        -0.403919   \n",
       "9           2.666667      2.622222  ...   -1.209522        -0.389716   \n",
       "10          2.657778      2.640000  ...    0.061109        -0.389716   \n",
       "11          2.031111      1.982222  ...    0.061109        -0.389716   \n",
       "12          2.124444      2.084444  ...    0.061109        -0.389716   \n",
       "13          0.511111      0.484444  ...    0.061109        -0.389716   \n",
       "14          0.164444      0.137778  ...    0.061109        -0.389716   \n",
       "15          2.528889      2.502222  ...    0.061109        -0.403919   \n",
       "16          3.391111      3.364444  ...    0.061109        -0.389716   \n",
       "17          2.511111      2.457778  ...    0.061109        -0.403919   \n",
       "18          2.337778      2.306667  ...    0.061109        -0.403919   \n",
       "19          2.195556      2.151111  ...    0.061109        -0.421277   \n",
       "20          2.528889      2.528889  ...   -1.209522        -0.421277   \n",
       "21          3.235556      3.204444  ...    0.061109        -0.421277   \n",
       "22          3.102222      3.048889  ...    0.061109        -0.452839   \n",
       "23          2.568889      2.537778  ...   -1.209522        -0.452839   \n",
       "24          2.466667      2.457778  ...   -1.209522        -0.437058   \n",
       "25          1.582222      1.555556  ...   -1.209522        -0.421277   \n",
       "26          2.631111      2.586667  ...    0.061109        -0.437058   \n",
       "27          2.448889      2.444444  ...   -1.209522        -0.437058   \n",
       "28          2.204444      2.151111  ...    0.061109        -0.437058   \n",
       "29          1.151111      1.120000  ...    0.061109        -0.421277   \n",
       "...              ...           ...  ...         ...              ...   \n",
       "393856      0.204444      0.195556  ...   -1.209522        -1.587465   \n",
       "393857      0.204444      0.195556  ...   -2.480153        -1.604824   \n",
       "393858      0.204444      0.195556  ...   -1.209522        -1.604824   \n",
       "393859      0.204444      0.195556  ...   -1.209522        -1.604824   \n",
       "393860      0.204444      0.195556  ...    0.061109        -1.604824   \n",
       "393861      0.204444      0.195556  ...    0.061109        -1.604824   \n",
       "393862      0.204444      0.195556  ...   -1.209522        -1.604824   \n",
       "393863      0.204444      0.195556  ...    0.061109        -1.604824   \n",
       "393864      0.204444      0.195556  ...   -2.480153        -1.604824   \n",
       "393865      0.204444      0.195556  ...   -1.209522        -1.604824   \n",
       "393866      0.204444      0.195556  ...   -1.209522        -1.604824   \n",
       "393867      0.204444      0.195556  ...   -1.209522        -1.604824   \n",
       "393868      0.204444      0.195556  ...    0.061109        -1.604824   \n",
       "393869      0.204444      0.195556  ...    0.061109        -1.604824   \n",
       "393870      0.204444      0.195556  ...    1.331741        -1.604824   \n",
       "393871      0.204444      0.195556  ...    0.061109        -1.604824   \n",
       "393872      0.204444      0.195556  ...   -1.209522        -1.604824   \n",
       "393873      0.204444      0.195556  ...   -1.209522        -1.604824   \n",
       "393874      0.204444      0.195556  ...    0.061109        -1.604824   \n",
       "393875      0.204444      0.195556  ...    0.061109        -1.604824   \n",
       "393876      0.204444      0.195556  ...    0.061109        -1.604824   \n",
       "393877      0.204444      0.195556  ...    0.061109        -1.604824   \n",
       "393878      0.204444      0.195556  ...    0.061109        -1.620604   \n",
       "393879      0.204444      0.195556  ...    0.061109        -1.604824   \n",
       "393880      0.204444      0.195556  ...    0.061109        -1.604824   \n",
       "393881      0.204444      0.195556  ...    0.061109        -1.620604   \n",
       "393882      0.204444      0.195556  ...    0.061109        -1.620604   \n",
       "393883      0.204444      0.195556  ...   -1.209522        -1.620604   \n",
       "393884      0.204444      0.195556  ...    0.061109        -1.620604   \n",
       "393885      0.204444      0.195556  ...    0.061109        -1.636385   \n",
       "\n",
       "         int_tmp  pitch1_ng5_tmp  pitch2_ng5_tmp  pitch3_ng5_tmp  \\\n",
       "0       0.014918        1.307692        1.123077        0.783077   \n",
       "1      -0.002291        1.307692        1.123077        0.783077   \n",
       "2      -0.002291        1.307692        1.123077        0.783077   \n",
       "3      -0.002291        1.307692        1.123077        0.783077   \n",
       "4       0.014918        1.307692        1.123077        0.783077   \n",
       "5      -0.002291        1.307692        1.106154        0.783077   \n",
       "6      -0.002291        1.307692        1.106154        0.783077   \n",
       "7      -0.002291        1.307692        1.106154        0.783077   \n",
       "8      -0.002291        1.307692        1.106154        0.783077   \n",
       "9      -0.002291        1.307692        1.106154        0.783077   \n",
       "10     -0.002291        1.307692        1.106154        0.783077   \n",
       "11     -0.002291        1.307692        1.106154        0.783077   \n",
       "12     -0.002291        1.290769        1.106154        0.783077   \n",
       "13     -0.002291        1.290769        1.090769        0.783077   \n",
       "14     -0.002291        1.290769        1.090769        0.783077   \n",
       "15     -0.002291        1.290769        1.090769        0.783077   \n",
       "16     -0.002291        1.290769        1.090769        0.783077   \n",
       "17     -0.002291        1.290769        1.090769        0.783077   \n",
       "18     -0.023326        1.290769        1.090769        0.783077   \n",
       "19     -0.023326        1.276923        1.090769        0.769231   \n",
       "20     -0.002291        1.276923        1.090769        0.783077   \n",
       "21     -0.023326        1.276923        1.076923        0.783077   \n",
       "22     -0.023326        1.276923        1.076923        0.769231   \n",
       "23     -0.002291        1.276923        1.076923        0.769231   \n",
       "24     -0.023326        1.276923        1.076923        0.769231   \n",
       "25     -0.002291        1.276923        1.076923        0.769231   \n",
       "26     -0.023326        1.276923        1.076923        0.769231   \n",
       "27     -0.023326        1.276923        1.076923        0.769231   \n",
       "28     -0.023326        1.276923        1.061538        0.769231   \n",
       "29     -0.023326        1.260000        1.061538        0.769231   \n",
       "...          ...             ...             ...             ...   \n",
       "393856 -1.665902        0.783077        0.815385        1.061538   \n",
       "393857 -1.665902        0.783077        0.815385        1.061538   \n",
       "393858 -1.665902        0.815385        0.815385        1.046154   \n",
       "393859 -1.665902        0.815385        0.830769        1.046154   \n",
       "393860 -1.665902        0.815385        0.846154        1.046154   \n",
       "393861 -1.665902        0.830769        0.846154        1.046154   \n",
       "393862 -1.665902        0.846154        0.846154        1.046154   \n",
       "393863 -1.665902        0.846154        0.860000        1.046154   \n",
       "393864 -1.665902        0.846154        0.860000        1.046154   \n",
       "393865 -1.665902        0.860000        0.875385        1.046154   \n",
       "393866 -1.686936        0.860000        0.892308        1.046154   \n",
       "393867 -1.665902        0.875385        0.907692        1.046154   \n",
       "393868 -1.665902        0.892308        0.907692        1.046154   \n",
       "393869 -1.665902        0.892308        0.923077        1.046154   \n",
       "393870 -1.665902        0.892308        0.923077        1.029231   \n",
       "393871 -1.665902        0.907692        0.936923        1.029231   \n",
       "393872 -1.665902        0.923077        0.936923        1.029231   \n",
       "393873 -1.665902        0.923077        0.936923        1.029231   \n",
       "393874 -1.665902        0.936923        0.952308        1.013846   \n",
       "393875 -1.686936        0.936923        0.969231        1.013846   \n",
       "393876 -1.686936        0.936923        0.969231        1.013846   \n",
       "393877 -1.686936        0.952308        0.984615        1.013846   \n",
       "393878 -1.665902        0.969231        1.000000        1.013846   \n",
       "393879 -1.665902        0.969231        1.000000        1.000000   \n",
       "393880 -1.665902        0.984615        1.000000        1.000000   \n",
       "393881 -1.665902        1.000000        1.013846        1.000000   \n",
       "393882 -1.665902        1.000000        1.013846        1.000000   \n",
       "393883 -1.686936        1.000000        1.013846        1.000000   \n",
       "393884 -1.665902        1.013846        1.029231        1.000000   \n",
       "393885 -1.686936        1.013846        1.046154        1.000000   \n",
       "\n",
       "        pitch1_ng5_DC  pitch2_ng5_DC  pitch3_ng5_DC  group  \n",
       "0                1.36           0.00           1.56      1  \n",
       "1                0.44           2.88          -2.60      1  \n",
       "2                1.76           0.60           2.56      1  \n",
       "3                2.80          -0.48           0.12      1  \n",
       "4               -0.88           1.72           0.92      1  \n",
       "5                0.20          -0.92          -1.48      1  \n",
       "6               -0.16          -0.80          -1.76      1  \n",
       "7               -0.76          -0.92           1.12      1  \n",
       "8                0.64           1.32           0.36      1  \n",
       "9                0.20           0.52           0.40      1  \n",
       "10               2.80           0.32          -0.04      1  \n",
       "11               0.08          -0.64          -2.68      1  \n",
       "12               0.12          -3.28           1.20      1  \n",
       "13               0.72          -1.56           1.32      1  \n",
       "14              -0.92          -0.32          -1.68      1  \n",
       "15               0.64          -2.72           2.12      1  \n",
       "16              -1.56           1.68           2.80      1  \n",
       "17               1.08           0.76           0.32      1  \n",
       "18               1.44           2.40           2.60      1  \n",
       "19               0.96           0.40           1.36      1  \n",
       "20               0.16           0.48          -1.88      1  \n",
       "21               0.72          -0.24           1.72      1  \n",
       "22              -1.56          -0.72           2.76      1  \n",
       "23               0.16           2.64          -0.76      1  \n",
       "24               0.96           0.28           1.20      1  \n",
       "25               2.92           0.20           2.56      1  \n",
       "26               0.00          -0.36           0.00      1  \n",
       "27               1.84          -1.08           0.36      1  \n",
       "28               0.80           1.32          -1.20      1  \n",
       "29               0.20           1.92           0.12      1  \n",
       "...               ...            ...            ...    ...  \n",
       "393856           1.72           0.12          -0.44   3853  \n",
       "393857          -0.88          -0.60           0.04   3853  \n",
       "393858           0.48           0.28           0.52   3853  \n",
       "393859          -0.52          -0.52          -0.40   3853  \n",
       "393860           1.84           1.32           0.28   3853  \n",
       "393861           0.40           0.24          -1.08   3853  \n",
       "393862          -0.56          -0.76          -0.36   3853  \n",
       "393863          -0.56           0.08           1.60   3853  \n",
       "393864          -0.64          -0.12          -1.12   3853  \n",
       "393865          -0.60           0.00           1.80   3853  \n",
       "393866           0.64          -0.24          -0.36   3853  \n",
       "393867          -0.64           0.36          -1.48   3853  \n",
       "393868          -0.68           0.00           0.52   3853  \n",
       "393869          -0.56          -0.12           1.92   3853  \n",
       "393870           1.76           0.12           0.08   3853  \n",
       "393871          -0.44           0.76          -0.08   3853  \n",
       "393872           0.84           0.20          -0.60   3853  \n",
       "393873           0.52          -0.60           1.44   3853  \n",
       "393874          -0.56           1.72           1.48   3853  \n",
       "393875          -0.36           1.32          -0.76   3853  \n",
       "393876           1.88           0.24          -1.12   3853  \n",
       "393877          -0.76          -1.56          -0.36   3853  \n",
       "393878          -0.76           1.36           1.36   3853  \n",
       "393879           1.36           0.28          -0.20   3853  \n",
       "393880           1.24           1.32          -0.40   3853  \n",
       "393881          -0.52          -0.04          -1.48   3853  \n",
       "393882           0.32          -2.36           1.84   3853  \n",
       "393883           1.20           0.12           1.28   3853  \n",
       "393884           0.76          -0.40          -0.60   3853  \n",
       "393885          -0.36           1.52           0.60   3853  \n",
       "\n",
       "[393886 rows x 28 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_15_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "\n",
    "test_data_15 = data_15_df.copy()\n",
    "\n",
    "test_data_15['flag'] = flag15\n",
    "\n",
    "test_data_15\n",
    "\n",
    "%matplotlib inline\n",
    "\n",
    "plt.figure()\n",
    "plt.subplot(6,4,1)\n",
    "test_data_15.boxplot(column=['generator_speed'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,2)\n",
    "test_data_15.boxplot(column=['wind_speed'],by='flag')#差别较小\n",
    "\n",
    "plt.subplot(6,4,3)\n",
    "test_data_15.boxplot(column=['power'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,4)\n",
    "test_data_15.boxplot(column=['wind_direction'],by='flag')#差别较小\n",
    "\n",
    "plt.subplot(6,4,5)\n",
    "test_data_15.boxplot(column=['yaw_position'],by='flag')#差别较小\n",
    "\n",
    "plt.subplot(6,4,6)\n",
    "test_data_15.boxplot(column=['yaw_speed'],by='flag')#差别较小\n",
    "\n",
    "plt.subplot(6,4,7)\n",
    "test_data_15.boxplot(column=['pitch1_angle'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,8)\n",
    "test_data_15.boxplot(column=['pitch2_angle'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,9)\n",
    "test_data_15.boxplot(column=['pitch3_angle'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,10)\n",
    "test_data_15.boxplot(column=['pitch1_speed'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,11)\n",
    "test_data_15.boxplot(column=['pitch2_speed'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,12)\n",
    "test_data_15.boxplot(column=['pitch1_moto_tmp'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,13)\n",
    "test_data_15.boxplot(column=['acc_x'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,14)\n",
    "test_data_15.boxplot(column=['acc_y'],by='flag')#差别较小\n",
    "\n",
    "plt.subplot(6,4,15)\n",
    "test_data_15.boxplot(column=['environment_tmp'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,16)\n",
    "test_data_15.boxplot(column=['int_tmp'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,17)\n",
    "test_data_15.boxplot(column=['pitch1_ng5_tmp'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,18)\n",
    "test_data_15.boxplot(column=['pitch2_ng5_tmp'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,19)\n",
    "test_data_15.boxplot(column=['pitch3_ng5_tmp'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,20\n",
    "test_data_15.boxplot(column=['pitch1_ng5_DC'],by='flag')#差别较小\n",
    "\n",
    "plt.subplot(6,4,21)\n",
    "test_data_15.boxplot(column=['pitch2_ng5_tmp'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,22)\n",
    "test_data_15.boxplot(column=['pitch3_ng5_tmp'],by='flag')#差别较大\n",
    "\n",
    "plt.subplot(6,4,23)\n",
    "test_data_15.boxplot(column=['group'],by='flag')#差别较大\n",
    "            \n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['time', 'wind_speed', 'generator_speed', 'power', 'wind_direction',\n",
       "       'wind_direction_mean', 'yaw_position', 'yaw_speed', 'pitch1_angle',\n",
       "       'pitch2_angle', 'pitch3_angle', 'pitch1_speed', 'pitch2_speed',\n",
       "       'pitch3_speed', 'pitch1_moto_tmp', 'pitch2_moto_tmp', 'pitch3_moto_tmp',\n",
       "       'acc_x', 'acc_y', 'environment_tmp', 'int_tmp', 'pitch1_ng5_tmp',\n",
       "       'pitch2_ng5_tmp', 'pitch3_ng5_tmp', 'pitch1_ng5_DC', 'pitch2_ng5_DC',\n",
       "       'pitch3_ng5_DC', 'group'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_15_df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Help on function boxplot in module pandas.core.frame:\n",
      "\n",
      "boxplot(self, column=None, by=None, ax=None, fontsize=None, rot=0, grid=True, figsize=None, layout=None, return_type=None, **kwds)\n",
      "    Make a box plot from DataFrame column optionally grouped by some columns or\n",
      "    other inputs\n",
      "    \n",
      "    Parameters\n",
      "    ----------\n",
      "    data : the pandas object holding the data\n",
      "    column : column name or list of names, or vector\n",
      "        Can be any valid input to groupby\n",
      "    by : string or sequence\n",
      "        Column in the DataFrame to group by\n",
      "    ax : Matplotlib axes object, optional\n",
      "    fontsize : int or string\n",
      "    rot : label rotation angle\n",
      "    figsize : A tuple (width, height) in inches\n",
      "    grid : Setting this to True will show the grid\n",
      "    layout : tuple (optional)\n",
      "        (rows, columns) for the layout of the plot\n",
      "    return_type : {'axes', 'dict', 'both'}, default 'dict'\n",
      "        The kind of object to return. 'dict' returns a dictionary\n",
      "        whose values are the matplotlib Lines of the boxplot;\n",
      "        'axes' returns the matplotlib axes the boxplot is drawn on;\n",
      "        'both' returns a namedtuple with the axes and dict.\n",
      "    \n",
      "        When grouping with ``by``, a dict mapping columns to ``return_type``\n",
      "        is returned.\n",
      "    \n",
      "    kwds : other plotting keyword arguments to be passed to matplotlib boxplot\n",
      "           function\n",
      "    \n",
      "    Returns\n",
      "    -------\n",
      "    lines : dict\n",
      "    ax : matplotlib Axes\n",
      "    (ax, lines): namedtuple\n",
      "    \n",
      "    Notes\n",
      "    -----\n",
      "    Use ``return_type='dict'`` when you want to tweak the appearance\n",
      "    of the lines after plotting. In this case a dict containing the Lines\n",
      "    making up the boxes, caps, fliers, medians, and whiskers is returned.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "from pandas import DataFrame\n",
    "help(DataFrame.boxplot)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}
